public string SavecounterParty(CounterParty counterParty)
 {
     using (LoanPriceEntities context = new LoanPriceEntities())
     {
         if (counterParty.ID <= 0)
         {
             if (context.CounterParties.Where(s => s.Name == counterParty.Name).Count() == 0)
             {
                 context.AddToCounterParties(counterParty);
                 context.SaveChanges();
                 return "CounterParty is added successfully";
             }
             else
                 return "Entry of the same Name is already exists.";
         }
         else
         {
             if (context.CounterParties.Where(s => s.Name == counterParty.Name && s.ID != counterParty.ID).Count() == 0)
             {
                 context.CounterParties.Attach(counterParty);
                 context.ObjectStateManager.ChangeObjectState(counterParty, System.Data.EntityState.Modified);
                 context.SaveChanges();
                 return "CounterParty is Updated successfully";
             }
             else
                 return "Entry of the same Name is already exists.";
         }
     }
 }
 /// <summary>
 /// Create a new CounterParty object.
 /// </summary>
 /// <param name="id">Initial value of the ID property.</param>
 public static CounterParty CreateCounterParty(global::System.Int32 id)
 {
     CounterParty counterParty = new CounterParty();
     counterParty.ID = id;
     return counterParty;
 }
        protected void btnCPSave_Click(object sender, EventArgs e)
        {
            CounterParty model = new CounterParty();
            CounterPartyBL bl = new CounterPartyBL();

            model.Type = txtCPType.SelectedValue.Trim();
            model.Name = txtCPName.Text.Trim();
            model.Region = txtCPRegion.SelectedValue;
            if (!string.IsNullOrEmpty(hfCPID.Value))
            {
                model.ID = Convert.ToInt32(hfCPID.Value);
                LogActivity("CounterParty Updated", "Email has been updated", string.Empty);
            }
            else
            {
                LogActivity("CounterParty Created", "Email has been created", string.Empty);
            }
            string str = bl.SavecounterParty(model);
            BindCounterParties();
            if (str != "Entry of the same Name is already exists.")
            {
                hfCPID.Value = string.Empty;
            }

            RadWindowManager1.RadAlert(str, 330, 180, "realedge associates", "alertCallBackFn");
        }
 /// <summary>
 /// Deprecated Method for adding a new object to the CounterParties EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.
 /// </summary>
 public void AddToCounterParties(CounterParty counterParty)
 {
     base.AddObject("CounterParties", counterParty);
 }
        private static List<CounterParty> ExtractCounterPartyList(DataTable csvData, List<string> columnNames)
        {
            List<CounterParty> importedList = new List<CounterParty>();
            foreach (DataRow row in csvData.Rows)
            {
                CounterParty model = new CounterParty();
                // Get All properties
                PropertyInfo[] properties = model.GetType().GetProperties();
                foreach (PropertyInfo pInfo in properties)
                {
                    if (columnNames.Contains(pInfo.Name))
                    {
                        object value = row[pInfo.Name];
                        TypeConverter typeConverter = TypeDescriptor.GetConverter(pInfo.PropertyType);
                        object propValue = null;
                        if (typeConverter.GetType().FullName == "System.ComponentModel.NullableConverter")
                        {
                            if (value.ToString().Trim() == "1")
                            {
                                propValue = typeConverter.ConvertFromString(("True"));
                            }
                        }
                        else
                            propValue = typeConverter.ConvertFromString((value.ToString()));

                        // Set value on the property
                        pInfo.SetValue(model, propValue, null);
                    }
                }
                importedList.Add(model);
            }
            return importedList;
        }