public static void Insert(MemberShipEntity memberShipEntity)
{
try
{
var com = new SqlCommand("INSERT_MEMBERSHIP", Connect.ToDatabase());
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@ID", memberShipEntity.ID);
com.Parameters.AddWithValue("@MembershipType", memberShipEntity.MembershipType);
com.Parameters.AddWithValue("@DiscountValue", memberShipEntity.DiscountValue);
com.Parameters.AddWithValue("@DiscountText", memberShipEntity.DiscountText);
com.Parameters.AddWithValue("@Other", memberShipEntity.Other);
com.Parameters.AddWithValue("@CreateBy", memberShipEntity.CreatedBy);
com.Parameters.AddWithValue("@CreateDate", memberShipEntity.CreatedDate);
com.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), @"Could not find Stored Procedure");
}
finally
{
if (Connect.ToDatabase().State != ConnectionState.Closed)
{
;
}
}
{
Connect.ToDatabase().Close();
}
}
public FrmMemberShip(bool isCanSave = true, Guid?id = null)
{
InitializeComponent();
if (id != null)
{
membershipID = (Guid)id;
MemberShipEntity memberShipEntity = new MemberShipEntity();
memberShipEntity = MembershipDao.GetByID(id);
this.Text = this.Text + membershipID;
txtMemberShipType.Text = memberShipEntity.MembershipType;
txtDiscountValue.Text = memberShipEntity.DiscountValue.ToString();
txtDiscountText.Text = memberShipEntity.DiscountText;
txtOther.Text = memberShipEntity.Other;
}
btnSaveClose.Enabled = btnSaveNew.Enabled = isCanSave;
}
private void Save()
{
SaveCompleted = true;
errorProvider1.Clear();
MemberShipEntity memberShipEntity = new MemberShipEntity();
memberShipEntity.MembershipType = txtMemberShipType.Text;
memberShipEntity.DiscountValue = int.Parse(txtDiscountValue.Text);
memberShipEntity.DiscountText = txtDiscountText.Text;
memberShipEntity.Other = txtOther.Text;
if (membershipID != Guid.Empty)
{
memberShipEntity.ID = membershipID;
memberShipEntity.Update(USER.UserName);
MembershipDao.Update(memberShipEntity);
}
else
{
memberShipEntity.ID = Guid.NewGuid();
memberShipEntity.Create(USER.UserName);
MembershipDao.Insert(memberShipEntity);
}
}
public static MemberShipEntity GetByID(Guid?id)
{
MemberShipEntity memberShipEntity = new MemberShipEntity();
try
{
string query = string.Format("SELECT*FROM MEMBERSHIP WHERE ID='{0}'", id);
SqlCommand cmd = new SqlCommand(query, Connect.ToDatabase());
cmd.CommandTimeout = 10000;
var reader = cmd.ExecuteReader();
int i = reader.FieldCount;
if (reader.HasRows)
{
while (reader.Read())
{
memberShipEntity.ID = (Guid)reader["ID"];
memberShipEntity.MembershipType = reader["MembershipType"].ToString();
memberShipEntity.DiscountValue = int.Parse(reader["DiscountValue"].ToString());
memberShipEntity.DiscountText = reader["DiscountText"].ToString();
memberShipEntity.Other = reader["Other"].ToString();
}
}
reader.Close();
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
finally
{
if (Connect.ToDatabase().State != ConnectionState.Closed)
{
Connect.ToDatabase().Close();
}
}
return(memberShipEntity);
}
